package leaveSystem.dao;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;

import leaveSystem.model.Leave;

public interface LeaveDAO {
	public List<Leave> loadAll(Connection conn) throws SQLException;
	public void insertLeave(Connection conn, Leave valueObject) throws SQLException,Exception;
	public void updateLeave(Connection conn, Leave valueObject)throws DAOException, Exception;
	public void deleteLeave(Connection conn, Leave valueObject) throws DAOException, SQLException ;
	public void deleteAllLeave(Connection conn) throws SQLException;
	public List<Leave> findLeave(Connection conn, Leave valueObject) throws SQLException;
	public int countDaysByLeaveType(Connection conn,Leave valueObject) throws Exception;
	public List<Leave> findLeaveByEmpId(Connection conn,int empid) throws Exception;
}
